Vehicle File Import

Introduction

This will import vehicle file to Cloud SQL for PostgreSQL

Fields

Column Position	Description	Datatype	Validation	Max length	Mandatory	Example
A	Vehicle Reg Number	String	A-Z and 0-9 & All Special Char	10	Y	ABC123
B	Vehicle Id	Number	0-9	5	Y	1
C	VIN	String	A-Z and 0-9	17	Y	ABC2D4GHY47524999

Importing a file

Preparation

1. Upload the file with filename as vehicle_reg.csv into fnp-imports/modulus storage bucket

Validation

1. Go to Cloud Scheduler
2. Run Modulus_vehicle_file_validation job (job name could be different on other env)

Importing

1. Go to Cloud Scheduler
2. Run Modulus_vehicle_file_import job (job name could be different on other env)

NOTE:

If the import would throw memory error like Memory limit of 512 MiB exceeded with 515 MiB used, increase the memory for the service, run the import and revert back the memory to default(512mb).

Testing

1. Data will be inserted to Cloud SQL for PostgreSQL under fpn database in table modulus_vehicle.

Status: Accepted
Category: Protected
Authored By: Gladson on Jan 5, 2024

Revisions